﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of ArticleAttachmentGroup(files)">
  <Sql >
	  SELECT        ArticleFileAttachments.id AS filesid, ArticleFileGroups.id, ArticleFileGroups.authorizedArticleId, ArticleFileGroups.unauthorizedArticleId,
	  ArticleFileAttachments.filePathName AS filesfilePathName, ArticleFileAttachments.fileCacheName AS filesfileCacheName, ArticleFileAttachments.description AS filesdescription
	  FROM            ArticleFileAttachments INNER JOIN
	  ArticleFileGroups ON ArticleFileAttachments.fileGroupId = ArticleFileGroups.id
	  WHERE        (ArticleFileGroups.articleId = @articleId)
  </Sql>
  <Param name="articleId" type="UniqueIdentifier" />
</AdoNetDataAccess>
